API

Procurement APIs

GET procurement/imported-invoices/{importedSupplierInvoiceId}

Imported supplier invoice details for the provided identifer

HTTP method GET
URI https://api.rambase.net/procurement/imported-invoices/{importedSupplierInvoiceId}
Supported formats Xml, Html, Json (ex. $format=json)
- URI parameter {importedSupplierInvoiceId} Imported supplier invoice identifier
Integer, minimum 100000
Custom fields Custom fields supported
Successful HTTP status code 200
API resource identifier 2811, version 47

The following body must be added to the request. Mouse over fieldnames for description and other useful information about the fields. Note that fields in bold are required/mandatory.

Format:
1
1

The query string is placed after the resource URL, seperated with a questionmark (?). The query string is composed of a series of query parameters with values. See the page about query parameters on how to use these parameters.

$showDomainDescriptions Boolean, optional Set to "true" to include domain descriptions for fields using domain values. See the Domain values page for more information. Default value is false.
$lang String, optional Specifies the language used in the response, following the 3-letter ISO-639-1 [lll]
$access_token String, optional After successful login you get an access token which needs to be provided in all API requests. Even though it is possible to pass this token as query parameter, we recommended passing it using the HTTP request header as described in Authorization. Note that all access tokens have an expiration time.
$db String, optional Set the database/company for the request
$format String, optional Set the format of the response to use for the request. Accepted values are "xml", "html", "jsonstream", "json"
$useMinimumVersion Integer, optional Used to run a new version of an API resource when your API client is running a deprecated API resource. See the Breaking changes page for more information.
$select String, optional Use to define the fields to return in the response. Accepts a comma-separated list of field names. See the Expand and select page for more information.
$showCustomFields Boolean, optional Set to "true" to include custom fields. Default value is false.

Read more about filters and sorting on how to use filter parameters and named filters.

Read more about filters and sorting on how to use sortable parameters

Requesting this resource will yield the following response. Mouse over fieldnames (or fieldgroups) for descriptions and other useful information about the fields. Fields colored in grey is expandable fields.

Please note that some fields may be removed from the response, based on user roles/duties/permissions.

Format:
1
<ImportedSupplierInvoice>
2
     <ImportedSupplierInvoiceId
ImportedSupplierInvoiceId

Imported supplier invoice identifier

>
{Integer}</ImportedSupplierInvoiceId>
3
     <Status
Status

Status of imported supplier invoice

Possible domain values can be found here

>
{Integer}</Status>
4
     <ImportedAt
ImportedAt

The date and time when the file was imported

>
{Datetime}</ImportedAt>
5
     <ExternalReference
ExternalReference

Unique identifier of the file. Used to make sure that the same file is not procesed more than once.

>
{String}</ExternalReference>
6
     <RegistrationDate
RegistrationDate

The issue date to the invoice

>
{Date}</RegistrationDate>
7
     <SuppliersReference
SuppliersReference

The reference to the imported supplier invoice

>
{String}</SuppliersReference>
8
     <SuppliersReferenceNumber
SuppliersReferenceNumber

Supplier invoice number generated by the supplier invoicing system

>
{String}</SuppliersReferenceNumber>
9
     <Currency
Currency

The currency to the imported supplier invoice

>
{String}</Currency>
10
     <IsCreditNote
IsCreditNote

Is the imported invoice from type credit note

>
{Boolean}</IsCreditNote>
11
     <ImportedBy
ImportedBy

The PID to the user that imported the file

>
12
          <UserId
UserId

User identifier

>
{Integer}</UserId>
13
          <Name
Name

Name of the user

>
{String}</Name>
14
          <FirstName
FirstName

First name of the user

>
{String}</FirstName>
15
          <UserLink
UserLink

User reference

>
{String}</UserLink>
16
     </ImportedBy>
17
     <ImportedFile
ImportedFile

Refers to the file document where the file are stored

>
18
          <FileVersionId
FileVersionId

File identifier

>
{Integer}</FileVersionId>
19
          <FileVersionLink
FileVersionLink

File reference

>
{String}</FileVersionLink>
20
     </ImportedFile>
21
     <BuyersContact>
22
          <Name
Name

Name of the RamBase contact (legal entity or person)

>
{String}</Name>
23
          <Phone
Phone

Phone number of the RamBase contact

>
{String}</Phone>
24
          <Email
Email

E-mail of the RamBase contact

>
{String}</Email>
25
     </BuyersContact>
26
     <VATAccounting>
27
          <Currency
Currency

The currency used for VAT to the imported supplier invoice

>
{String}</Currency>
28
          <Date
Date

The date when the VAT becomes accountable

>
{Date}</Date>
29
          <VATAmount
VATAmount

Total amount of VAT in VAT currency on the invoice

>
{Decimal}</VATAmount>
30
          <VATRegistrationNumber
VATRegistrationNumber

VAT registration number of the company which should be used for the invoice or credit.

>
{String}</VATRegistrationNumber>
31
     </VATAccounting>
32
     <Totals>
33
          <Currency
Currency

The currency to the imported supplier invoice

>
{String}</Currency>
34
          <FreightAmount
FreightAmount

Freight of the invoice

>
{Decimal}</FreightAmount>
35
          <FeeAmount
FeeAmount

Fee of the invoice

>
{Decimal}</FeeAmount>
36
          <SubTotalAmount
SubTotalAmount

Total net amount on the invoice

>
{Decimal}</SubTotalAmount>
37
          <VATAmount
VATAmount

Total amount of VAT on the invoice

>
{Decimal}</VATAmount>
38
          <TotalAmount
TotalAmount

Total net amount on the invoice

>
{Decimal}</TotalAmount>
39
          <RoundOffAmount
RoundOffAmount

The round off to the imported supplier invoice

>
{Decimal}</RoundOffAmount>
40
     </Totals>
41
     <Payment>
42
          <DueDate
DueDate

The due date of the imported supplier invoice

>
{Date}</DueDate>
43
          <AccountName
AccountName

The bank account name to the payment receiver

>
{String}</AccountName>
44
          <AccountNumber
AccountNumber

The bank account number to the payment receiver

>
{String}</AccountNumber>
45
          <IBAN
IBAN

The international bank account number (IBAN) to the payment receiver

>
{String}</IBAN>
46
          <SWIFTCode
SWIFTCode

The bank identification code (BIC) to the account to the payment receiver

>
{String}</SWIFTCode>
47
          <SuppliersReference
SuppliersReference

The reference to the payment receiver

>
{String}</SuppliersReference>
48
     </Payment>
49
     <Supplier>
50
          <Name
Name

The name of the supplier

>
{String}</Name>
51
          <LegalEntityIdentifier
LegalEntityIdentifier

The enterprise number to the supplier

>
{String}</LegalEntityIdentifier>
52
          <InvoiceAddress>
53
               <Attention
Attention

The attention to the supplier

>
{String}</Attention>
54
               <AddressLine1
AddressLine1

The street name to the supplier

>
{String}</AddressLine1>
55
               <AddressLine2
AddressLine2

The additional street name to the supplier

>
{String}</AddressLine2>
56
               <Region
Region

The state to the supplier

>
{String}</Region>
57
               <PostalCode
PostalCode

The postal code to the supplier

>
{String}</PostalCode>
58
               <City
City

The city to the supplier

>
{String}</City>
59
               <CountryCode
CountryCode

The country code to the supplier

>
{String}</CountryCode>
60
               <Country
Country

Name of country

>
{String}</Country>
61
          </InvoiceAddress>
62
          <SupplierReference
SupplierReference

The account to the supplier

>
63
               <SupplierId
SupplierId

RamBase supplier identifier

>
{Integer}</SupplierId>
64
               <FirstName
FirstName

Firstname/givenname if the supplier is a person

>
{String}</FirstName>
65
               <Name
Name

Name of supplier (name of company or surname/familyname/lastname of a person)

>
{String}</Name>
66
               <SupplierLink
SupplierLink

Supplier reference

>
{String}</SupplierLink>
67
          </SupplierReference>
68
          <Contact>
69
               <Name
Name

Name of the suppliers contact (legal entity or person)

>
{String}</Name>
70
               <Phone
Phone

Phone number of the suppliers contact

>
{String}</Phone>
71
               <Email
Email

E-mail of the suppliers contact

>
{String}</Email>
72
          </Contact>
73
     </Supplier>
74
     <ShippedFrom>
75
          <AddressLine1
AddressLine1

The street name to the shipped from address

>
{String}</AddressLine1>
76
          <AddressLine2
AddressLine2

The additional street name to the shipped from address

>
{String}</AddressLine2>
77
          <PostalCode
PostalCode

The postal code to the shipped from address

>
{String}</PostalCode>
78
          <City
City

The city to the shipped from address

>
{String}</City>
79
          <Region
Region

The state to the shipped from address

>
{String}</Region>
80
          <CountryCode
CountryCode

The country code to the shipped from address

>
{String}</CountryCode>
81
          <Country
Country

Name of country

>
{String}</Country>
82
          <AddressReferences
AddressReferences

The identifier to the shipped from address

>
83
               <AddressId
AddressId

Address identifier

>
{Integer}</AddressId>
84
               <Name
Name

Name of receiver (Name of company or last name of a person). Note that default invoice address must have the same name as the customer.

>
{String}</Name>
85
               <FirstName
FirstName

Firstname if the receiver is a person. Note that default invoice address must have the same firstname as the customer.

>
{String}</FirstName>
86
               <AddressLink
AddressLink

Supplier address reference

>
{String}</AddressLink>
87
          </AddressReferences>
88
     </ShippedFrom>
89
     <ShippedTo>
90
          <AddressLine1
AddressLine1

The street name of the shipped to address

>
{String}</AddressLine1>
91
          <AddressLine2
AddressLine2

The additional street name of the shipped to address

>
{String}</AddressLine2>
92
          <PostalCode
PostalCode

The postal code to the shipped to address

>
{String}</PostalCode>
93
          <City
City

The city to the shipped to address

>
{String}</City>
94
          <Region
Region

The state of the shipped to address

>
{String}</Region>
95
          <CountryCode
CountryCode

The country code to the shipped to address

>
{String}</CountryCode>
96
          <Country
Country

Name of country

>
{String}</Country>
97
          <AddressReference
AddressReference

Reference to the shipped to address. Can be a reference to location address, customer address or supplier address

>
98
               <Description
Description

Description of address reference, Ex. if reference is to a location, this description will be the name of the location.

>
{String}</Description>
99
               <Reference>
100
                    <ObjectId
ObjectId

Identifier of the object

>
{Integer}</ObjectId>
101
                    <ObjectType
ObjectType

Type of object

>
{String}</ObjectType>
102
                    <ObjectLink
ObjectLink

API reference to the object

>
{String}</ObjectLink>
103
                    <ItemId
ItemId

Item-number of the object

>
{Integer}</ItemId>
104
                    <ItemType
ItemType

Type of item

>
{String}</ItemType>
105
                    <ItemLink
ItemLink

API reference to the item

>
{String}</ItemLink>
106
               </Reference>
107
          </AddressReference>
108
     </ShippedTo>
109
     <BacklogObject
BacklogObject

Reference to a backlog object in RamBase based on information on the received supplier invoice.

>
110
          <ObjectId
ObjectId

Identifier of the object

>
{Integer}</ObjectId>
111
          <ObjectType
ObjectType

Type of object

>
{String}</ObjectType>
112
          <Assignee
Assignee

The user who has been assigned to work with this object.

>
113
               <UserId
UserId

User identifier

>
{Integer}</UserId>
114
               <Name
Name

Name of the user

>
{String}</Name>
115
               <FirstName
FirstName

First name of the user

>
{String}</FirstName>
116
               <UserLink
UserLink

User reference

>
{String}</UserLink>
117
          </Assignee>
118
          <RamBaseKey
RamBaseKey

Internal RamBase identifier of the object/item

>
{String}</RamBaseKey>
119
          <ObjectLink
ObjectLink

API reference to the object

>
{String}</ObjectLink>
120
     </BacklogObject>
121
</ImportedSupplierInvoice>
1
{
2
     "importedSupplierInvoice": {
3
          "importedSupplierInvoiceId
ImportedSupplierInvoiceId

Imported supplier invoice identifier

":
"{Integer}",
4
          "status
Status

Status of imported supplier invoice

Possible domain values can be found here

":
"{Integer}",
5
          "importedAt
ImportedAt

The date and time when the file was imported

":
"{Datetime}",
6
          "externalReference
ExternalReference

Unique identifier of the file. Used to make sure that the same file is not procesed more than once.

":
"{String}",
7
          "registrationDate
RegistrationDate

The issue date to the invoice

":
"{Date}",
8
          "suppliersReference
SuppliersReference

The reference to the imported supplier invoice

":
"{String}",
9
          "suppliersReferenceNumber
SuppliersReferenceNumber

Supplier invoice number generated by the supplier invoicing system

":
"{String}",
10
          "currency
Currency

The currency to the imported supplier invoice

":
"{String}",
11
          "isCreditNote
IsCreditNote

Is the imported invoice from type credit note

":
"{Boolean}",
12
          "importedBy
ImportedBy

The PID to the user that imported the file

":
{
13
               "userId
UserId

User identifier

":
"{Integer}",
14
               "name
Name

Name of the user

":
"{String}",
15
               "firstName
FirstName

First name of the user

":
"{String}",
16
               "userLink
UserLink

User reference

":
"{String}"
17
          },
18
          "importedFile
ImportedFile

Refers to the file document where the file are stored

":
{
19
               "fileVersionId
FileVersionId

File identifier

":
"{Integer}",
20
               "fileVersionLink
FileVersionLink

File reference

":
"{String}"
21
          },
22
          "buyersContact": {
23
               "name
Name

Name of the RamBase contact (legal entity or person)

":
"{String}",
24
               "phone
Phone

Phone number of the RamBase contact

":
"{String}",
25
               "email
Email

E-mail of the RamBase contact

":
"{String}"
26
          },
27
          "vATAccounting": {
28
               "currency
Currency

The currency used for VAT to the imported supplier invoice

":
"{String}",
29
               "date
Date

The date when the VAT becomes accountable

":
"{Date}",
30
               "vATAmount
VATAmount

Total amount of VAT in VAT currency on the invoice

":
"{Decimal}",
31
               "vATRegistrationNumber
VATRegistrationNumber

VAT registration number of the company which should be used for the invoice or credit.

":
"{String}"
32
          },
33
          "totals": {
34
               "currency
Currency

The currency to the imported supplier invoice

":
"{String}",
35
               "freightAmount
FreightAmount

Freight of the invoice

":
"{Decimal}",
36
               "feeAmount
FeeAmount

Fee of the invoice

":
"{Decimal}",
37
               "subTotalAmount
SubTotalAmount

Total net amount on the invoice

":
"{Decimal}",
38
               "vATAmount
VATAmount

Total amount of VAT on the invoice

":
"{Decimal}",
39
               "totalAmount
TotalAmount

Total net amount on the invoice

":
"{Decimal}",
40
               "roundOffAmount
RoundOffAmount

The round off to the imported supplier invoice

":
"{Decimal}"
41
          },
42
          "payment": {
43
               "dueDate
DueDate

The due date of the imported supplier invoice

":
"{Date}",
44
               "accountName
AccountName

The bank account name to the payment receiver

":
"{String}",
45
               "accountNumber
AccountNumber

The bank account number to the payment receiver

":
"{String}",
46
               "iBAN
IBAN

The international bank account number (IBAN) to the payment receiver

":
"{String}",
47
               "sWIFTCode
SWIFTCode

The bank identification code (BIC) to the account to the payment receiver

":
"{String}",
48
               "suppliersReference
SuppliersReference

The reference to the payment receiver

":
"{String}"
49
          },
50
          "supplier": {
51
               "name
Name

The name of the supplier

":
"{String}",
52
               "legalEntityIdentifier
LegalEntityIdentifier

The enterprise number to the supplier

":
"{String}",
53
               "invoiceAddress": {
54
                    "attention
Attention

The attention to the supplier

":
"{String}",
55
                    "addressLine1
AddressLine1

The street name to the supplier

":
"{String}",
56
                    "addressLine2
AddressLine2

The additional street name to the supplier

":
"{String}",
57
                    "region
Region

The state to the supplier

":
"{String}",
58
                    "postalCode
PostalCode

The postal code to the supplier

":
"{String}",
59
                    "city
City

The city to the supplier

":
"{String}",
60
                    "countryCode
CountryCode

The country code to the supplier

":
"{String}",
61
                    "country
Country

Name of country

":
"{String}"
62
               },
63
               "supplierReference
SupplierReference

The account to the supplier

":
{
64
                    "supplierId
SupplierId

RamBase supplier identifier

":
"{Integer}",
65
                    "firstName
FirstName

Firstname/givenname if the supplier is a person

":
"{String}",
66
                    "name
Name

Name of supplier (name of company or surname/familyname/lastname of a person)

":
"{String}",
67
                    "supplierLink
SupplierLink

Supplier reference

":
"{String}"
68
               },
69
               "contact": {
70
                    "name
Name

Name of the suppliers contact (legal entity or person)

":
"{String}",
71
                    "phone
Phone

Phone number of the suppliers contact

":
"{String}",
72
                    "email
Email

E-mail of the suppliers contact

":
"{String}"
73
               }
74
          },
75
          "shippedFrom": {
76
               "addressLine1
AddressLine1

The street name to the shipped from address

":
"{String}",
77
               "addressLine2
AddressLine2

The additional street name to the shipped from address

":
"{String}",
78
               "postalCode
PostalCode

The postal code to the shipped from address

":
"{String}",
79
               "city
City

The city to the shipped from address

":
"{String}",
80
               "region
Region

The state to the shipped from address

":
"{String}",
81
               "countryCode
CountryCode

The country code to the shipped from address

":
"{String}",
82
               "country
Country

Name of country

":
"{String}",
83
               "addressReferences
AddressReferences

The identifier to the shipped from address

":
{
84
                    "addressId
AddressId

Address identifier

":
"{Integer}",
85
                    "name
Name

Name of receiver (Name of company or last name of a person). Note that default invoice address must have the same name as the customer.

":
"{String}",
86
                    "firstName
FirstName

Firstname if the receiver is a person. Note that default invoice address must have the same firstname as the customer.

":
"{String}",
87
                    "addressLink
AddressLink

Supplier address reference

":
"{String}"
88
               }
89
          },
90
          "shippedTo": {
91
               "addressLine1
AddressLine1

The street name of the shipped to address

":
"{String}",
92
               "addressLine2
AddressLine2

The additional street name of the shipped to address

":
"{String}",
93
               "postalCode
PostalCode

The postal code to the shipped to address

":
"{String}",
94
               "city
City

The city to the shipped to address

":
"{String}",
95
               "region
Region

The state of the shipped to address

":
"{String}",
96
               "countryCode
CountryCode

The country code to the shipped to address

":
"{String}",
97
               "country
Country

Name of country

":
"{String}",
98
               "addressReference
AddressReference

Reference to the shipped to address. Can be a reference to location address, customer address or supplier address

":
{
99
                    "description
Description

Description of address reference, Ex. if reference is to a location, this description will be the name of the location.

":
"{String}",
100
                    "reference": {
101
                         "objectId
ObjectId

Identifier of the object

":
"{Integer}",
102
                         "objectType
ObjectType

Type of object

":
"{String}",
103
                         "objectLink
ObjectLink

API reference to the object

":
"{String}",
104
                         "itemId
ItemId

Item-number of the object

":
"{Integer}",
105
                         "itemType
ItemType

Type of item

":
"{String}",
106
                         "itemLink
ItemLink

API reference to the item

":
"{String}"
107
                    }
108
               }
109
          },
110
          "backlogObject
BacklogObject

Reference to a backlog object in RamBase based on information on the received supplier invoice.

":
{
111
               "objectId
ObjectId

Identifier of the object

":
"{Integer}",
112
               "objectType
ObjectType

Type of object

":
"{String}",
113
               "assignee
Assignee

The user who has been assigned to work with this object.

":
{
114
                    "userId
UserId

User identifier

":
"{Integer}",
115
                    "name
Name

Name of the user

":
"{String}",
116
                    "firstName
FirstName

First name of the user

":
"{String}",
117
                    "userLink
UserLink

User reference

":
"{String}"
118
               },
119
               "ramBaseKey
RamBaseKey

Internal RamBase identifier of the object/item

":
"{String}",
120
               "objectLink
ObjectLink

API reference to the object

":
"{String}"
121
          }
122
     }
123
}

Possible error codes the response might return:

Error 100050 HTTP 403 No admittance as customer {0}
Error 100053 HTTP 403 You have only admittance to your own suppliers
Error 100001 HTTP 404 Address not found